Tabela ServicePerformance

Definicja tabeli ServicePerformance

Name

ServicePerformance

Code

ServicePerformance

Comment

Wykonanie uslugi


Lista kolumn tabeli ServicePerformance

Name

Code

PeriodID

PeriodID

ServID

ServID

UnitsCount

UnitsCount

OrderCostAccountID

OrderCostAccountID

PerfCostAccountID

PerfCostAccountID


Kolumna PeriodID tabeli ServicePerformance

Definicja kolumny PeriodID tabeli ServicePerformance

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli ServicePerformance

Definicja kolumny ServID tabeli ServicePerformance

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitsCount tabeli ServicePerformance

Definicja kolumny UnitsCount tabeli ServicePerformance

Name

UnitsCount

Code

UnitsCount

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna OrderCostAccountID tabeli ServicePerformance

Definicja kolumny OrderCostAccountID tabeli ServicePerformance

Name

OrderCostAccountID

Code

OrderCostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfCostAccountID tabeli ServicePerformance

Definicja kolumny PerfCostAccountID tabeli ServicePerformance

Name

PerfCostAccountID

Code

PerfCostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ServicePerformance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServicePerformance

Definicja klucza Identifier_1 tabeli ServicePerformance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment